To Populate values to COBie Spreadsheet
-
The Instruction sheet consist data of Title, Version, Construction Worksheet, Region, Purpose etc.
-
The following table represents values populated to Contact Sheet.
Email The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The value of the date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value is populated from the Role dropdown list under the IFC Author section in the Author tab of IFC Export dialog.
Company The value is populated from the Name textbox under the Organization section in the Author tab of IFC Export dialog.
Phone The value is populated from the Phone textbox under the IFC Author section in the Author tab of IFC Export dialog.
ExternalSystem The ExternalSystem is a reference column used to link the data to external contractor or COBie data.
ExternalObject The ExternalObject is a reference column used to link the data to external contractor or COBie data.
ExternalIdentifier The ExternalIdentifier is a reference column used to link the data to external contractor or COBie data.
Department The value is populated from the Name textbox under the Organization section in the Author tab of IFC Export dialog.
OrganizationCode If the data is not applicable or not available, enter n/a in the column.
GivenName The value is populated from the First Name textbox under the IFC Author section in the Author tab of IFC Export dialog.
FamilyName The value is populated from the Last Name textbox under the IFC Author section in the Author tab of IFC Export dialog.
Street The value is populated from the Address textbox under the Organization section in the Author tab of IFC Export dialog.
PostalBox If the data is not applicable or not available, enter n/a in the column.
Town The value is populated from the City textbox under the Organization section in the Author tab of IFC Export dialog.
StateRegion The value is populated from the State textbox under the Organization section in the Author tab of IFC Export dialog.
PostalCode The value is populated from the Postal Code textbox under the Organization section in the Author tab of IFC Export dialog.
Country The value is populated from the Country textbox under the Organization section in the Author tab of IFC Export dialog.
-
The following table represents values populated to Facility Sheet.
Name The Name is populated from the Floor Manager dialog.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
ProjectName The Project Name is populated from the Floor Manager dialog.
SiteName The Site Name is populated from the Floor manager dialog.
LinearUnits The value is populated from the PickLists sheet in the LinearUnits column.
AreaUnits The value is populated from the PickLists sheet in the AreaUnits column.
VolumeUnits The value is populated from the PickLists sheet in the VolumeUnits column.
CurrencyUnit The value is populated from the Picklists sheet.
AreaMeasurement The value is populated from the Picklists sheet.
ExternalSystem The ExternalSystem is a reference column used to link the data to external contractor or COBie data.
ExternalProjectObject The ExternalProjectObject is a reference column used to link the data to external contractor or COBie data.
ExternalProjectIdentifier The ExternalProjectIdentifier is a reference column used to link the data to external contractor or COBie data.
ExternalSiteObject The ExternalSiteObject is a reference column used to link the data to external contractor or COBie data.
ExternalSiteIdentifier The ExternalSiteIdentifier is a reference column used to link the data to external contractor or COBie data.
ExternalFacilityObject The ExternalFacilityObject is a reference column used to link the data to external contractor or COBie data.
ExternalFacilityIdentifier The ExternalFacilityIdentifier is a reference column used to link the data to external contractor or COBie data.
Description The value is populated from ID|Description under Identification section in the Floor manager dialog after selecting the building.
ProjectDescription The value of Project Description is populated from the Floor Manager dialog.
SiteDescription The value of Site Description is populated from the Floor manager dialog.
-
The following table represents values populated to Floor Sheet.
Name The value is populated from the Name column of Floor Manager dialog.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description The value is populated from ID|Description under Identification section in the Floor manager dialog after selecting the floor.
Elevation The value is populated from the Elevation column in the Floor Manager dialog.
Height The value is populated from the Floor-to-Floor column in the Floor Manager dialog.
-
The following table represents values populated to Space Sheet.
Name The value is populated from the Label textbox in Create Space Properties dialog.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value is populated from the drop-down list of the Classification section in the Edit Space Properties dialog.
FloorName The value is populated from the Location|Floor textbox under Space section in the Edit Space Properties dialog.
Description If the data is not applicable or not available, enter n/a in the column.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
RoomTag The value is populated from the RoomTag textbox under COBie_Space section in the Edit Space properties dialog.
UsableHeight The value is populated from the Ceiling Height textbox in the Space properties dialog.
GrossArea The value is populated from the Space properties dialog.
NetArea The value is populated from the Space properties dialog.
-
The following table represents values populated to Zone Sheet.
Name The value is populated from the IfcZones Name textbox under IfcZone section in the Edit Space properties dialog.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
SpaceNames The value is populated from the Label textbox in Create Space properties dialog.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description The value is populated from the IfcZones Name textbox under IfcZone section in the Edit Space properties dialog.
-
The following table represents values populated to Type Sheet.
Name The name of Catalog Item selected from Space properties dialog is populated in the Name column.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
Description The value is populated from the Label textbox of the properties dialog.
AssetType The value is populated from AssetType under COBie_Asset in the properties dialog.
Manufacturer The value is populated from the Manufacturer | Name under Manufacturer section of properties dialog.
ModelNumber The value is populated from the Manufacturer | Model No. under Manufacturer section of properties dialog .
WarrantyGuarantorParts The value is populated from the WarrantyGuarantorParts under COBie_Warranty section of properties dialog.
WarrantyDurationParts The value is populated from the WarrantyDurationParts under COBie_Warranty section of properties dialog.
WarrantyGuarantorLabor The value is populated from the WarrantyGuarantorLabor under COBie_Warranty section of properties dialog.
WarrantyDurationLabor The value is populated from the WarrantyDurationLabor under COBie_Warranty section of properties dialog.
WarrantyGuarantorUnit The value is populated from the WarrantyGuarantorUnit under COBie_Warranty section of properties dialog.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
NominalLength The value is populated from the NominalLength textbox under COBie_Specification section of properties dialog.
NominalWidth The value is populated from the NominalWidth textbox under COBie_Specification section of properties dialog.
NominalHeight The value is populated from the NominalHeight textbox under COBie_Specification section of properties dialog.
ModelReference The value is populated from the ModelReference textbox under Pset_ManufacturerTypeInformation section of properties dialog.
Shape The value is populated from the Shape textbox under COBie_Specification section of properties dialog.
Size The value is populated from the Size textbox under COBie_Specification section of properties dialog.
Color The value is populated from the Color textbox under COBie_Specification section of properties dialog.
Finish The value is populated from the Finish textbox under COBie_Specification section of properties dialog.
Grade The value is populated from the Grade textbox under COBie_Specification section of properties dialog.
Material The value is populated from the Material textbox under COBie_Specification section of properties dialog.
Constituents The value is populated from the Constituents textbox under COBie_Specification section of properties dialog.
Features The value is populated from the Features textbox under COBie_Specification section of properties dialog.
AccessibilityPerformance The value is populated from the AccessibilityPerformance textbox under COBie_Specification section of properties dialog.
CodePerformance The value is populated from the CodePerformance textbox under COBie_Specification section of properties dialog.
SustainabilityPerformance The value is populated from the SustainabilityPerformance textbox under COBie_Specification section of properties dialog.
-
The following table represents values populated to Component Sheet. The following is an example of Door component.
Name The name of component is populated in the Name column.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
TypeName The Catalog Item name is populated in the TypeName column.
Space The value of spaces placed in the DGN is populated in the Space column. Description The value is populated from the ID | Type ID textbox of Identification section of properties dialog.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
SerialNumber The value is populated from the SerialNumber textbox under the Pset_ManufacturerOccurrence section of properties dialog.
InstallationDate The value entered by the user in the InstallationDate textbox in the properties dialog is populated in the InstallationDate column.
WarrantyStartDate The value entered by the user in the WarrantyStartDate textbox in the properties dialog is populated in the WarrantyStartDate column.
TagNumber The value specified in the TagNumber textbox under the COBie_Specification section of Properties dialog is populated in the TagNumber column.
BarCode The value is populated from the BarCode textbox under the Pset_ManufacturerOccurrence section of properties dialog.
AssetIdentifier The value is populated from the AssetIdentifier textbox under the COBie_Specification section of properties dialog.
-
The following table represents values populated to System Sheet.
Name The System Name is populated to the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
ComponentNames The value is populated from PickList sheet.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description If the data is not applicable or not available, enter n/a in the column.
-
The following table represents values populated to Assembly Sheet.
Name The Aggregate Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog is populated in the CreatedBy column.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
SheetName The name of component is populated in the SheetName column.
ParentName The value is populated from PickList sheet.
ChildNames If the data is not applicable or not available, enter n/a in the column.
AssemblyType The AssemblyType is a reference column used to link the data to external contractor or COBie data.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description If the data is not applicable or not available, enter n/a in the column.
-
The following table represents values populated to Connection Sheet.
Name The Connection Element Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
RowName1 The name of component is populated in the RowName1 column.
RowName2 The name of component is populated in the RowName2 column.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description If the data is not applicable or not available, enter n/a in the column.
-
The following table represents values populated to Spare Sheet.
Name The Construction Equipment Resource Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
TypeName The value populated in the TypeName column is the name of Catalog Item selected from Properties dialog.
Suppliers The value is populated from PickList sheet.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description Value must be provided or mention 'n/a'.
SetNumber The value specified in the SetNumber textbox under COBie_Spare section is populated in the SetNumber column.
PartNumber The value specified in the PartNumber textbox under COBie_Spare section is populated in the PartNumber column.
-
The following table represents values populated to Resource Sheet.
Name The Construction Equipment Resource Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
-
The following table represents values populated to Job Sheet.
Name The Task Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
Status The value is populated from PickList sheet.
TypeName The value populated in the TypeName column is the name of Catalog Item selected from Space Properties dialog.
Description If the data is not applicable or not available, enter n/a in the column.
Duration If the data is not applicable or not available, enter 0 in the column.
DurationUnit The value is populated from PickList sheet.
Start If the data is not applicable or not available, enter 0 in the column.
TaskStartUnit The value is populated from PickList sheet.
Frequency If the data is not applicable or not available, enter 0 in the column.
FrequencyUnit The value is populated from PickList sheet.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
-
The following table represents values populated to Impact Sheet.
Name The Property Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
ImpactType The value is populated from PickList sheet.
ImpactStage The value is populated from PickList sheet.
SheetName The name of component is populated in the SheetName column.
RowName The name of component is populated in the RowName column.
Value If the data is not applicable or not available, enter n/a in the column.
ImpactUnit The value is populated from PickList sheet.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
-
The following table represents values populated to Document Sheet.
Name The Document Information is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
ApprovalBy The Document Information Intended Use value is populated in the ApprovalBy column.
Stage The Document Information Scope value is populated in the Stage column.
SheetName The name of component is populated in the SheetName column.
RowName The name of component is populated in the RowName column.
Directory The Document Information Location value is populated in the Directory column.
File The Document Information Identification value is populated in the File column.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description If the data is not applicable or not available, enter n/a in the column.
Reference The document information is populated in the Reference column.
-
The following table represents populated to Attribute Sheet.
Name The Property Name is populated in the Name column.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
SheetName The name of component is populated in the SheetName column.
RowName The name of component is populated in the RowName column.
Value All the values entered while placing components are populated in the Value column.
Unit The unit name is populated from PickList sheet.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description The Property Name is populated in the Description column.
AllowedValues The column consists of predefined values.
-
The following table represents values populated to Coordinate Sheet.
Name The Building Storey Name , Space Name or Product Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
SheetName The name of component is populated in the SheetName column.
RowName The name of component is populated in the RowName column.
CoordinateXAxis The value of X-Axis is populated in the CoordinateXAxis column.
CoordinateYAxis The value of Y-Axis is populated in the CoordinateYAxis column.
CoordinateZAxis The value of Z-Axis is populated in the CoordinateZAxis column.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
ClockwiseRotation The value of angle at which the component rotates clockwise is populated in the ClockwiseRotation column.
ElevationRotation The value of angle at which the component rotates at an elevation is populated in the ElevationRotation column.
YawRotation The value of angle at which the component rotates vertically is populated in the YawRotation column.
-
The following table represents values populated to Issue Sheet.
Name The Building Storey Name , Space Name or Product Name is populated in the spreadsheet.
CreatedBy The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Type The value is populated from PickList sheet.
Risk The value is populated from PickList sheet.
Chance The value is populated from PickList sheet.
Impact The value is populated from PickList sheet.
SheetName1 The name of component is populated in the SheetName1 column.
RowName1 The name of component is populated in the RowName1 column.
SheetName2 The name of component is populated in the SheetName2 column.
RowName2 The name of component is populated in the RowName2 column.
Description If the data is not applicable or not available, enter n/a in the column.
Owner The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
Mitigation The value of Preventive Measures is populated in the column.
ExtSystem The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.